// 蜂窝蜜造平台生成代码，如手工更改，请添加到 .beeignore 忽略生成

package com.fowo.api.entity;

import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableLogic;
import com.baomidou.mybatisplus.annotation.TableName;
import com.baomidou.mybatisplus.extension.handlers.JacksonTypeHandler;
import com.fasterxml.jackson.annotation.JsonFormat;
import com.fowo.api.common.annotaion.*;
import com.fowo.api.common.mybatis.handlers.SysFileListTypeHandler;
import com.fowo.api.sys.entity.SysFile;
import io.swagger.v3.oas.annotations.media.Schema;
import java.io.Serializable;
import java.util.List;
import lombok.EqualsAndHashCode;
import lombok.Getter;
import lombok.Setter;

/**
 * WalmartStock
 */
@DS("ds24")
@Getter
@Setter
@TableName(value = "walmart_stock", autoResultMap = true)
@Schema(title = "WFS库存")
public class WalmartStock implements Serializable {

  /**
   * 编号
   */
  @TableField(value = "`id`")
  @TableId(type = IdType.ASSIGN_ID)
  @Schema(title = "编号")
  private Long id;

  /**
   * 创建时间
   */
  @TableField(value = "`create_time`")
  @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
  @Schema(title = "创建时间")
  private java.util.Date createTime;

  /**
   * 创建人
   */
  @TableField(value = "`create_user`")
  @Schema(title = "创建人")
  private Long createUser;

  /**
   * 更新时间
   */
  @TableField(value = "`last_update_time`")
  @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
  @Schema(title = "更新时间")
  private java.util.Date lastUpdateTime;

  /**
   * 更新人
   */
  @TableField(value = "`last_update_user`")
  @Schema(title = "更新人")
  private Long lastUpdateUser;

  /**
   * 删除标记
   */
  @TableField(value = "`del_flag`")
  @TableLogic
  @Schema(title = "删除标记")
  private Boolean delFlag;

  /**
   * 店铺
   */
  @TableField(value = "`sid`")
  @JoinField(ShopInfo.class)
  @Schema(title = "店铺")
  private Long sid;

  /**
   * 图片
   */
  @TableField(value = "`img`", typeHandler = SysFileListTypeHandler.class)
  @Schema(title = "图片")
  private List<SysFile> img;

  /**
   * MSKU
   */
  @TableField(value = "`msku`")
  @Schema(title = "MSKU")
  private String msku;

  /**
   * GTIN
   */
  @TableField(value = "`gtin`")
  @Schema(title = "GTIN")
  private String gtin;

  /**
   * 商品ID
   */
  @TableField(value = "`item_id`")
  @Schema(title = "商品ID")
  private String itemId;

  /**
   * 品名
   */
  @TableField(value = "`product_name`")
  @Schema(title = "品名")
  private String productName;

  /**
   * SKU
   */
  @TableField(value = "`sku`")
  @Schema(title = "SKU")
  private String sku;

  /**
   * 商品状态
   */
  @TableField(value = "`platform_product_status`")
  @Schema(title = "商品状态")
  private String platformProductStatus;

  /**
   * 总库存
   */
  @TableField(value = "`quantity`")
  @Schema(title = "总库存")
  private Integer quantity;

  /**
   * WFS可售
   */
  @TableField(value = "`available_quantity`")
  @Schema(title = "WFS可售")
  private Integer availableQuantity;

  /**
   * 无法入库
   */
  @TableField(value = "`unabled_warehousing_quantity`")
  @Schema(title = "无法入库")
  private Integer unabledWarehousingQuantity;

  /**
   * 标发在途
   */
  @TableField(value = "`inbound_quantity`")
  @Schema(title = "标发在途")
  private Integer inboundQuantity;

  /**
   * 3个月内库龄
   */
  @TableField(value = "`ats03_months`")
  @Schema(title = "3个月内库龄")
  private Integer ats03Months;

  /**
   * 3-6个月库龄
   */
  @TableField(value = "`ats36_months`")
  @Schema(title = "3-6个月库龄")
  private Integer ats36Months;

  /**
   * 6-9个月库龄
   */
  @TableField(value = "`ats69_months`")
  @Schema(title = "6-9个月库龄")
  private Integer ats69Months;

  /**
   * 9-12个月库龄
   */
  @TableField(value = "`ats912_months`")
  @Schema(title = "9-12个月库龄")
  private Integer ats912Months;

  /**
   * 12个月以上库龄
   */
  @TableField(value = "`ats1_years`")
  @Schema(title = "12个月以上库龄")
  private Integer ats1Years;

  /**
   * 近30天入库
   */
  @TableField(value = "`last30_days_units_received`")
  @Schema(title = "近30天入库")
  private Integer last30DaysUnitsReceived;

  /**
   * 近30天计划入库
   */
  @TableField(value = "`last30_days_po_units`")
  @Schema(title = "近30天计划入库")
  private Integer last30DaysPoUnits;

  /**
   * 标题
   */
  @TableField(value = "`title`")
  @Schema(title = "标题")
  private String title;

  /**
   * 品牌名称
   */
  @TableField(value = "`brand_name`")
  @Schema(title = "品牌名称")
  private String brandName;

  /**
   * 本地产品id
   */
  @TableField(value = "`pid`")
  @Schema(title = "本地产品id")
  private Long pid;

  /**
   * 店铺名
   */
  @TableField(value = "`shop_name`")
  @Schema(title = "店铺名")
  private String shopName;
}
